--Use CodeCamp;
GO

Declare @LocalOffsetHours int; Set @LocalOffsetHours = -4;
Declare @UTCOffsetHours2Local int; Set @UTCOffsetHours2Local = -4;

Select
	Top 100
	LogEntryID
	,DateAdd(hour,@LocalOffsetHours,LogTimeLocal) [Log Time Local]
	,DateAdd(hour,@UTCOffsetHours2Local,LogDbTimeUTC) [Log Time db]
	,[Level]
	,MachineName
	,ThreadId
	,RemoteIP
	,[Application]
	,UserName
	,URL
	,[Message]
	,Exception
	--,LogDbTimeUTC
	--,Logger
	--,[TimeStamp]
	--,*
From dbo.aspnetRgs_log4net
Order by LogEntryID Desc
